package com.example.administrator.recorddemo20181101.util.util;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class DBConnection extends SQLiteOpenHelper
{

	public DBConnection(Context context)
	{
		super(context, "lisheng.db", null, 1);
	}

	@Override
	public void onCreate(SQLiteDatabase db)
	{
		db.execSQL("create table  userinfo(_id integer primary key autoincrement not null,uname varchar(20),usex varchar(2),uage integer);");
		db.execSQL("insert into   userinfo values(null,'������','��',108)");
		db.execSQL("insert into   userinfo values(null,'��˹֮','��',12)");
		db.execSQL("insert into   userinfo values(null,'��ʩӨ','Ů',36)");
		db.execSQL("insert into   userinfo values(null,'����','Ů',55)");
		db.execSQL("insert into   userinfo values(null,'����','��',76)");
		db.execSQL("insert into   userinfo values(null,'����','��',10)");
		db.execSQL("insert into   userinfo values(null,'��˾��','Ů',8)");
		db.execSQL("insert into   userinfo values(null,'��ˬ','��',35)");
		db.execSQL("insert into   userinfo values(null,'�º�','��',25)");
		db.execSQL("insert into   userinfo values(null,'�����','��',21)");
		db.execSQL("insert into   userinfo values(null,'����','��',58)");
		db.execSQL("insert into   userinfo values(null,'��Ʒ','��',69)");
		db.execSQL("insert into   userinfo values(null,'����','��',12)");
		db.execSQL("insert into   userinfo values(null,'Ф����','Ů',22)");
		db.execSQL("insert into   userinfo values(null,'�����','Ů',75)");
		db.execSQL("insert into   userinfo values(null,'����','��',33)");
		db.execSQL("insert into   userinfo values(null,'��ΰ','��',26)");
		db.execSQL("insert into   userinfo values(null,'����ɺ','Ů',12)");
		db.execSQL("insert into   userinfo values(null,'������','��',56)");
		db.execSQL("insert into   userinfo values(null,'������','Ů',88)");
		db.execSQL("insert into   userinfo values(null,'������','Ů',32)");
		db.execSQL("insert into   userinfo values(null,'Ԭ����','��',12)");
		db.execSQL("insert into   userinfo values(null,'������','��',56)");
		db.execSQL("insert into   userinfo values(null,'������','Ů',33)");
		db.execSQL("insert into   userinfo values(null,'��˼˼','Ů',12)");
	}

	@Override
	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2)
	{
		

	}

}
